Enhancing SQL with Set-Comparison Operators
نویسندگان
چکیده
Queries that involve words like "every", "only", etc., are generally difficult to formulate in SQL. In this paper, we analyze the problems and propose a set of set-comparison operators to enhance the usability of SQL. These operators allow users to formulate conventionally difficult queries in an easier way, greatly enhancing the user-friendliness of SQL. Keywords-Query Processing, SQL language, Set Theory
منابع مشابه
242-31: SQL Set Operators: So Handy Venn You Need Them
When it comes to combining data from multiple tables in the SQL Procedure, joins get most of the attention and subqueries are probably second. Often overlooked are the set operators (OUTER UNION, UNION, INTERSECT, and EXCEPT). This tutorial begins by relating OUTER UNION to similar functionality provided by the DATA step's SET statement, then explains and demonstrates the full repertoire of SET...
متن کاملUser-Defined Table Operators: Enhancing Extensibility for ORDBMS
Currently parallel object-relational database technology is setting the direction for the future of data management. A central enhancement of objectrelational database technology is the possibility to execute arbitrary user-defined functions within SQL statements. We show the limits of this approach and propose user-defined table operators as a new concept that allows the definition and impleme...
متن کاملTowards a Sufficient Set of Mutation Operators for Structured Query Language (SQL)
Test suites for database applications depend on adequate test data and real-world test faults for success. An automated tool is available that quantifies test data coverage for database queries written in SQL. An automated tool is also available that mimics realworld faults by mutating SQL, however tests have revealed that these simulated faults do not completely represent real-world faults. Th...
متن کاملMutating database queries
A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, including the handling of null values. Additional experiments are performed to explore whether the cost of executing mutants can be reduced using select...
متن کاملTMF Special Issue: Unlocking Data for Clinical Research - The German i2b2 Experience
Objective: Data from clinical care is increasingly being used for research purposes. The i2b2 platform has been introduced in some US research communities as a tool for data integration and querying be clinical users. The purpose of this project was to assess the applicability of i2b2 in Germany regarding use cases, functionality and integration with privacy enhancing tools. Methods: A set of f...
متن کامل